package com.ray.depot.table.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MaterialPropertyExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    /**
     *
     */
    public MaterialPropertyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @param orderByClause
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @param distinct
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @param criteria
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *
     * @param limitStart
     */
    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    /**
     *
     */
    public int getLimitStart() {
        return limitStart;
    }

    /**
     *
     * @param limitEnd
     */
    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    /**
     *
     */
    public int getLimitEnd() {
        return limitEnd;
    }

    /**
     * 类注释
     * GeneratedCriteria
     * 数据库表：dpt_material_property
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPropertyIdIsNull() {
            addCriterion("PROPERTY_ID is null");
            return (Criteria) this;
        }

        public Criteria andPropertyIdIsNotNull() {
            addCriterion("PROPERTY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyIdEqualTo(String value) {
            addCriterion("PROPERTY_ID =", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdNotEqualTo(String value) {
            addCriterion("PROPERTY_ID <>", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdGreaterThan(String value) {
            addCriterion("PROPERTY_ID >", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdGreaterThanOrEqualTo(String value) {
            addCriterion("PROPERTY_ID >=", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdLessThan(String value) {
            addCriterion("PROPERTY_ID <", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdLessThanOrEqualTo(String value) {
            addCriterion("PROPERTY_ID <=", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdLike(String value) {
            addCriterion("PROPERTY_ID like", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdNotLike(String value) {
            addCriterion("PROPERTY_ID not like", value, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdIn(List<String> values) {
            addCriterion("PROPERTY_ID in", values, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdNotIn(List<String> values) {
            addCriterion("PROPERTY_ID not in", values, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdBetween(String value1, String value2) {
            addCriterion("PROPERTY_ID between", value1, value2, "propertyId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdNotBetween(String value1, String value2) {
            addCriterion("PROPERTY_ID not between", value1, value2, "propertyId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdIsNull() {
            addCriterion("MATERIAL_ID is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIdIsNotNull() {
            addCriterion("MATERIAL_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialIdEqualTo(String value) {
            addCriterion("MATERIAL_ID =", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotEqualTo(String value) {
            addCriterion("MATERIAL_ID <>", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdGreaterThan(String value) {
            addCriterion("MATERIAL_ID >", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_ID >=", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLessThan(String value) {
            addCriterion("MATERIAL_ID <", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_ID <=", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLike(String value) {
            addCriterion("MATERIAL_ID like", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotLike(String value) {
            addCriterion("MATERIAL_ID not like", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdIn(List<String> values) {
            addCriterion("MATERIAL_ID in", values, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotIn(List<String> values) {
            addCriterion("MATERIAL_ID not in", values, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdBetween(String value1, String value2) {
            addCriterion("MATERIAL_ID between", value1, value2, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_ID not between", value1, value2, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialNoIsNull() {
            addCriterion("MATERIAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andMaterialNoIsNotNull() {
            addCriterion("MATERIAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialNoEqualTo(String value) {
            addCriterion("MATERIAL_NO =", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoNotEqualTo(String value) {
            addCriterion("MATERIAL_NO <>", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoGreaterThan(String value) {
            addCriterion("MATERIAL_NO >", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_NO >=", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoLessThan(String value) {
            addCriterion("MATERIAL_NO <", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_NO <=", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoLike(String value) {
            addCriterion("MATERIAL_NO like", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoNotLike(String value) {
            addCriterion("MATERIAL_NO not like", value, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoIn(List<String> values) {
            addCriterion("MATERIAL_NO in", values, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoNotIn(List<String> values) {
            addCriterion("MATERIAL_NO not in", values, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoBetween(String value1, String value2) {
            addCriterion("MATERIAL_NO between", value1, value2, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialNoNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_NO not between", value1, value2, "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameIsNull() {
            addCriterion("MATERIAL_PROPERTY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameIsNotNull() {
            addCriterion("MATERIAL_PROPERTY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameEqualTo(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME =", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameNotEqualTo(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME <>", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameGreaterThan(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME >", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME >=", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameLessThan(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME <", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME <=", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameLike(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME like", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameNotLike(String value) {
            addCriterion("MATERIAL_PROPERTY_NAME not like", value, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameIn(List<String> values) {
            addCriterion("MATERIAL_PROPERTY_NAME in", values, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameNotIn(List<String> values) {
            addCriterion("MATERIAL_PROPERTY_NAME not in", values, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameBetween(String value1, String value2) {
            addCriterion("MATERIAL_PROPERTY_NAME between", value1, value2, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_PROPERTY_NAME not between", value1, value2, "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIsNull() {
            addCriterion("MATERIAL_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIsNotNull() {
            addCriterion("MATERIAL_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusEqualTo(String value) {
            addCriterion("MATERIAL_STATUS =", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotEqualTo(String value) {
            addCriterion("MATERIAL_STATUS <>", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusGreaterThan(String value) {
            addCriterion("MATERIAL_STATUS >", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_STATUS >=", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLessThan(String value) {
            addCriterion("MATERIAL_STATUS <", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_STATUS <=", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLike(String value) {
            addCriterion("MATERIAL_STATUS like", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotLike(String value) {
            addCriterion("MATERIAL_STATUS not like", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIn(List<String> values) {
            addCriterion("MATERIAL_STATUS in", values, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotIn(List<String> values) {
            addCriterion("MATERIAL_STATUS not in", values, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusBetween(String value1, String value2) {
            addCriterion("MATERIAL_STATUS between", value1, value2, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_STATUS not between", value1, value2, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIsNull() {
            addCriterion("MNEMONIC_CODE is null");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIsNotNull() {
            addCriterion("MNEMONIC_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeEqualTo(String value) {
            addCriterion("MNEMONIC_CODE =", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotEqualTo(String value) {
            addCriterion("MNEMONIC_CODE <>", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeGreaterThan(String value) {
            addCriterion("MNEMONIC_CODE >", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeGreaterThanOrEqualTo(String value) {
            addCriterion("MNEMONIC_CODE >=", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLessThan(String value) {
            addCriterion("MNEMONIC_CODE <", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLessThanOrEqualTo(String value) {
            addCriterion("MNEMONIC_CODE <=", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLike(String value) {
            addCriterion("MNEMONIC_CODE like", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotLike(String value) {
            addCriterion("MNEMONIC_CODE not like", value, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeIn(List<String> values) {
            addCriterion("MNEMONIC_CODE in", values, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotIn(List<String> values) {
            addCriterion("MNEMONIC_CODE not in", values, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeBetween(String value1, String value2) {
            addCriterion("MNEMONIC_CODE between", value1, value2, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeNotBetween(String value1, String value2) {
            addCriterion("MNEMONIC_CODE not between", value1, value2, "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqIsNull() {
            addCriterion("UNIQUE_SEQ is null");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqIsNotNull() {
            addCriterion("UNIQUE_SEQ is not null");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqEqualTo(String value) {
            addCriterion("UNIQUE_SEQ =", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqNotEqualTo(String value) {
            addCriterion("UNIQUE_SEQ <>", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqGreaterThan(String value) {
            addCriterion("UNIQUE_SEQ >", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqGreaterThanOrEqualTo(String value) {
            addCriterion("UNIQUE_SEQ >=", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqLessThan(String value) {
            addCriterion("UNIQUE_SEQ <", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqLessThanOrEqualTo(String value) {
            addCriterion("UNIQUE_SEQ <=", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqLike(String value) {
            addCriterion("UNIQUE_SEQ like", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqNotLike(String value) {
            addCriterion("UNIQUE_SEQ not like", value, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqIn(List<String> values) {
            addCriterion("UNIQUE_SEQ in", values, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqNotIn(List<String> values) {
            addCriterion("UNIQUE_SEQ not in", values, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqBetween(String value1, String value2) {
            addCriterion("UNIQUE_SEQ between", value1, value2, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqNotBetween(String value1, String value2) {
            addCriterion("UNIQUE_SEQ not between", value1, value2, "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andSpecIsNull() {
            addCriterion("SPEC is null");
            return (Criteria) this;
        }

        public Criteria andSpecIsNotNull() {
            addCriterion("SPEC is not null");
            return (Criteria) this;
        }

        public Criteria andSpecEqualTo(String value) {
            addCriterion("SPEC =", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotEqualTo(String value) {
            addCriterion("SPEC <>", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThan(String value) {
            addCriterion("SPEC >", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThanOrEqualTo(String value) {
            addCriterion("SPEC >=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThan(String value) {
            addCriterion("SPEC <", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThanOrEqualTo(String value) {
            addCriterion("SPEC <=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLike(String value) {
            addCriterion("SPEC like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotLike(String value) {
            addCriterion("SPEC not like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecIn(List<String> values) {
            addCriterion("SPEC in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotIn(List<String> values) {
            addCriterion("SPEC not in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecBetween(String value1, String value2) {
            addCriterion("SPEC between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotBetween(String value1, String value2) {
            addCriterion("SPEC not between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andColorIsNull() {
            addCriterion("COLOR is null");
            return (Criteria) this;
        }

        public Criteria andColorIsNotNull() {
            addCriterion("COLOR is not null");
            return (Criteria) this;
        }

        public Criteria andColorEqualTo(String value) {
            addCriterion("COLOR =", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotEqualTo(String value) {
            addCriterion("COLOR <>", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThan(String value) {
            addCriterion("COLOR >", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThanOrEqualTo(String value) {
            addCriterion("COLOR >=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThan(String value) {
            addCriterion("COLOR <", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThanOrEqualTo(String value) {
            addCriterion("COLOR <=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLike(String value) {
            addCriterion("COLOR like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotLike(String value) {
            addCriterion("COLOR not like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorIn(List<String> values) {
            addCriterion("COLOR in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotIn(List<String> values) {
            addCriterion("COLOR not in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorBetween(String value1, String value2) {
            addCriterion("COLOR between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotBetween(String value1, String value2) {
            addCriterion("COLOR not between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("PRICE is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("PRICE =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("PRICE <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("PRICE >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRICE >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("PRICE <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRICE <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("PRICE in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("PRICE not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRICE between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRICE not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andBarCodeIsNull() {
            addCriterion("BAR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBarCodeIsNotNull() {
            addCriterion("BAR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBarCodeEqualTo(String value) {
            addCriterion("BAR_CODE =", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeNotEqualTo(String value) {
            addCriterion("BAR_CODE <>", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeGreaterThan(String value) {
            addCriterion("BAR_CODE >", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BAR_CODE >=", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeLessThan(String value) {
            addCriterion("BAR_CODE <", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeLessThanOrEqualTo(String value) {
            addCriterion("BAR_CODE <=", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeLike(String value) {
            addCriterion("BAR_CODE like", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeNotLike(String value) {
            addCriterion("BAR_CODE not like", value, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeIn(List<String> values) {
            addCriterion("BAR_CODE in", values, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeNotIn(List<String> values) {
            addCriterion("BAR_CODE not in", values, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeBetween(String value1, String value2) {
            addCriterion("BAR_CODE between", value1, value2, "barCode");
            return (Criteria) this;
        }

        public Criteria andBarCodeNotBetween(String value1, String value2) {
            addCriterion("BAR_CODE not between", value1, value2, "barCode");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNull() {
            addCriterion("INDEX_SORT is null");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNotNull() {
            addCriterion("INDEX_SORT is not null");
            return (Criteria) this;
        }

        public Criteria andIndexSortEqualTo(Integer value) {
            addCriterion("INDEX_SORT =", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotEqualTo(Integer value) {
            addCriterion("INDEX_SORT <>", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThan(Integer value) {
            addCriterion("INDEX_SORT >", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT >=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThan(Integer value) {
            addCriterion("INDEX_SORT <", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT <=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortIn(List<Integer> values) {
            addCriterion("INDEX_SORT in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotIn(List<Integer> values) {
            addCriterion("INDEX_SORT not in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT not between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNull() {
            addCriterion("CREATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNotNull() {
            addCriterion("CREATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgEqualTo(String value) {
            addCriterion("CREATE_BY_ORG =", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <>", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThan(String value) {
            addCriterion("CREATE_BY_ORG >", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG >=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThan(String value) {
            addCriterion("CREATE_BY_ORG <", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLike(String value) {
            addCriterion("CREATE_BY_ORG like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotLike(String value) {
            addCriterion("CREATE_BY_ORG not like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIn(List<String> values) {
            addCriterion("CREATE_BY_ORG in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotIn(List<String> values) {
            addCriterion("CREATE_BY_ORG not in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG not between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNull() {
            addCriterion("CREATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNotNull() {
            addCriterion("CREATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserEqualTo(String value) {
            addCriterion("CREATE_BY_USER =", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotEqualTo(String value) {
            addCriterion("CREATE_BY_USER <>", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThan(String value) {
            addCriterion("CREATE_BY_USER >", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER >=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThan(String value) {
            addCriterion("CREATE_BY_USER <", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER <=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLike(String value) {
            addCriterion("CREATE_BY_USER like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotLike(String value) {
            addCriterion("CREATE_BY_USER not like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIn(List<String> values) {
            addCriterion("CREATE_BY_USER in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotIn(List<String> values) {
            addCriterion("CREATE_BY_USER not in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER not between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNull() {
            addCriterion("UPDATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNotNull() {
            addCriterion("UPDATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG =", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <>", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThan(String value) {
            addCriterion("UPDATE_BY_ORG >", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG >=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThan(String value) {
            addCriterion("UPDATE_BY_ORG <", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLike(String value) {
            addCriterion("UPDATE_BY_ORG like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotLike(String value) {
            addCriterion("UPDATE_BY_ORG not like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG not in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG not between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNull() {
            addCriterion("UPDATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNotNull() {
            addCriterion("UPDATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserEqualTo(String value) {
            addCriterion("UPDATE_BY_USER =", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <>", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThan(String value) {
            addCriterion("UPDATE_BY_USER >", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER >=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThan(String value) {
            addCriterion("UPDATE_BY_USER <", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLike(String value) {
            addCriterion("UPDATE_BY_USER like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotLike(String value) {
            addCriterion("UPDATE_BY_USER not like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIn(List<String> values) {
            addCriterion("UPDATE_BY_USER in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotIn(List<String> values) {
            addCriterion("UPDATE_BY_USER not in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER not between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("IS_DELETE is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("IS_DELETE is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(String value) {
            addCriterion("IS_DELETE =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(String value) {
            addCriterion("IS_DELETE <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(String value) {
            addCriterion("IS_DELETE >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETE >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(String value) {
            addCriterion("IS_DELETE <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETE <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLike(String value) {
            addCriterion("IS_DELETE like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotLike(String value) {
            addCriterion("IS_DELETE not like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<String> values) {
            addCriterion("IS_DELETE in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<String> values) {
            addCriterion("IS_DELETE not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(String value1, String value2) {
            addCriterion("IS_DELETE between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(String value1, String value2) {
            addCriterion("IS_DELETE not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNull() {
            addCriterion("TENANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNotNull() {
            addCriterion("TENANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTenantIdEqualTo(String value) {
            addCriterion("TENANT_ID =", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(String value) {
            addCriterion("TENANT_ID <>", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThan(String value) {
            addCriterion("TENANT_ID >", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThanOrEqualTo(String value) {
            addCriterion("TENANT_ID >=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThan(String value) {
            addCriterion("TENANT_ID <", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThanOrEqualTo(String value) {
            addCriterion("TENANT_ID <=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLike(String value) {
            addCriterion("TENANT_ID like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotLike(String value) {
            addCriterion("TENANT_ID not like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdIn(List<String> values) {
            addCriterion("TENANT_ID in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotIn(List<String> values) {
            addCriterion("TENANT_ID not in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdBetween(String value1, String value2) {
            addCriterion("TENANT_ID between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotBetween(String value1, String value2) {
            addCriterion("TENANT_ID not between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andPropertyIdLikeInsensitive(String value) {
            addCriterion("upper(PROPERTY_ID) like", value.toUpperCase(), "propertyId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_ID) like", value.toUpperCase(), "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialNoLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_NO) like", value.toUpperCase(), "materialNo");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertyNameLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_PROPERTY_NAME) like", value.toUpperCase(), "materialPropertyName");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_STATUS) like", value.toUpperCase(), "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMnemonicCodeLikeInsensitive(String value) {
            addCriterion("upper(MNEMONIC_CODE) like", value.toUpperCase(), "mnemonicCode");
            return (Criteria) this;
        }

        public Criteria andUniqueSeqLikeInsensitive(String value) {
            addCriterion("upper(UNIQUE_SEQ) like", value.toUpperCase(), "uniqueSeq");
            return (Criteria) this;
        }

        public Criteria andSpecLikeInsensitive(String value) {
            addCriterion("upper(SPEC) like", value.toUpperCase(), "spec");
            return (Criteria) this;
        }

        public Criteria andColorLikeInsensitive(String value) {
            addCriterion("upper(COLOR) like", value.toUpperCase(), "color");
            return (Criteria) this;
        }

        public Criteria andBarCodeLikeInsensitive(String value) {
            addCriterion("upper(BAR_CODE) like", value.toUpperCase(), "barCode");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_ORG) like", value.toUpperCase(), "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_USER) like", value.toUpperCase(), "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_ORG) like", value.toUpperCase(), "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_USER) like", value.toUpperCase(), "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLikeInsensitive(String value) {
            addCriterion("upper(IS_DELETE) like", value.toUpperCase(), "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdLikeInsensitive(String value) {
            addCriterion("upper(TENANT_ID) like", value.toUpperCase(), "tenantId");
            return (Criteria) this;
        }
    }

    /**
     * 类注释
     * Criteria
     * 数据库表：dpt_material_property
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * 类注释
     * Criterion
     * 数据库表：dpt_material_property
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}